package com.jhhc.StormSurgeForecast.AstronomicalTide.Dao;


import com.jhhc.StormSurgeForecast.AstronomicalTide.Pojo.bdms_forecastsubscheme_b;
import org.apache.ibatis.annotations.Param;

import java.util.List;

/**
 * (bdms_forecastsubscheme_b)表数据库访问层
 *
 * @author makejava
 * @since 2023-12-07 09:31:57
 */

public interface bdms_forecastsubscheme_bMapper {

    /**
     * 通过ID查询单条数据
     *
     * @param pid 主键
     * @return 实例对象
     */
    bdms_forecastsubscheme_b queryById(@Param("pid") Integer pid, @Param("subfschemeid") String subfschemeid);
    List<bdms_forecastsubscheme_b> queryAll(@Param("mainSchemeId") String mainSchemeId);
    List<bdms_forecastsubscheme_b> getSubFschemeIdList(@Param("projectId") String projectId,
                                                           @Param("stcd") String stcd);
    List<bdms_forecastsubscheme_b> queryByPId(@Param("pid") Integer pid,@Param("forecastStationCode") String forecastStationCode
    ,@Param("tideType") Integer tideType,@Param("modelId") String modelId,@Param("nums") Integer nums);

    /**
     * 新增数据
     *
     * @param bdms_forecastsubscheme_b 实例对象
     * @return 影响行数
     */
    int insert(bdms_forecastsubscheme_b bdms_forecastsubscheme_b);


    List<bdms_forecastsubscheme_b>  queryKey(@Param("facid")  String facid);
    /**
     * 修改数据
     *
     * @param bdms_forecastsubscheme_b 实例对象
     * @return 影响行数
     */
    int update(bdms_forecastsubscheme_b bdms_forecastsubscheme_b);

    /**
     * 通过主键删除数据
     *
     * @param subForeSchemeIds 主键
     * @return 影响行数
     */
    int deleteById(@Param("subForeSchemeIds") List<String> subForeSchemeIds);


    int deleteByStcd(@Param("mainForeSchemeId") String mainForeSchemeId,@Param("stcd") String stcd);

}

